<?php
error_reporting(E_ALL);

include_once('../controller/includes/constants.php');
include_once('../controller/includes/Template.php');
include_once('../controller/includes/functions.php');

?>

<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title></title>
    </head>
    <body>
        <table border="0" cellspacing="5" cellpadding="5">
            <thead>
                <tr>
                   <th colspan="2"><?php include_once('../controller/includes/header.php'); ?></th>
                    
                </tr>
            </thead>
            <tbody>
                    
<?php
// put your code here
        $q = new Query;
$q
    ->select('*'
        
    )
    ->from('`categorieen`')
    ->order_by(
        array(
            '`categorieen`.`categorie` ASC',
           
        )
    )
    ->run();
    
$result = $q->run();
$count = $q->get_selected_count();

if (!($result && $count > 0)) {
    echo 'No users found.' . "\n";
}
else {
    while ($rows = mysql_fetch_array($result)) {
       
        echo'<tr><td>'. $rows['categorie'] . ' </td> <td><a href="categorie_edit.php?pid='.$rows['categorie_id'].'">detail</a></td></tr>';

    }
}


        ?>
                   
                   
                
                <tr>
                    <td></td>
                    <td></td>
                </tr>
            </tbody>
        </table>

    </body>
</html>
